Secrets from a SAS Technical Support Guy: Combining the Power of the SAS® Output Delivery System with Microsoft Excel Worksheets
نویسنده
چکیده
Business analysts commonly use Microsoft Excel with the SAS® System to answer difficult business questions. While you can use these applications independently of each other to obtain the information you need, you can also combine the power of those applications, using the SAS Output Delivery System (ODS) tagsets, to completely automate the process. This combination delivers a more efficient process that enables you to create fully functional and highly customized Excel worksheets within SAS. This paper starts by discussing common questions and problems that SAS Technical Support receives from users when they try to generate Excel worksheets. The discussion continues with methods for automating Excel worksheets using ODS tagsets and customizing your worksheets using the CSS style engine and extended tagsets. In addition, the paper discusses tips and techniques for migrating from the current MSOffice2K and ExcelXP tagsets to the new Excel destination, which generates output in the native Excel 2010 format.
منابع مشابه
Data Warehousing and Information Delivery: Success and Failure in Managed Care
This paper describes the use of the SAS System by a nationally recognized managed care organization to meet its information delivery needs. This paper is intended for managers and will detail the organization’s struggle with the issues surrounding data warehousing and information delivery. The paper will highlight our successful use of the SAS System to provide a full range of information deliv...
متن کاملFocusing healthcare quality improvement dollars: Using SAS for geographic targeting
Like many organizations, the health care quality improvement industry is charged with doing more with less. This can only be accomplished by careful scheduling of resources. Geographical differences in adherence to clinical guidelines have been demonstrated. In this paper, geographical analyses are used both to identify regions and providers for healthcare quality improvement targeting and to i...
متن کامل135-31: Combining the Power of ODS, Data Set Concatenation, and DDE to Output Customized Statistical Results from SAS® to Microsoft Excel
SAS is a widely used software package for statistical analyses, however presentation of customized results for reports and publications is cumbersome and time consuming if done manually and there is a high likelihood of incurring errors during the process. The method reported here makes the presentation of results easier and more efficient especially when a large number of variables are being t...
متن کاملUsing SAS Software to Analyze Sybase Performance on the Web
This paper provides a web-based system using SAS, HTML and CGI/PERL to provide rudimentary and complex Sybase DBMS performance metrics for Unix based system operations. Sybase SQL Server performance data is collected by Sybase Historical Server allowing for the collection of performance information with minimal impact on the server. The SAS System (Base SAS, Macro, STAT and SAS/Graph) is especi...
متن کاملSeamless Reporting Automation through the Integration of JMP, SAS, and VBA
The TiVo user interface (UI) is continuously enhanced for design. To monitor and improve UI performance, statistical tests are run on multiple test cases across various dimensions, and weekly reports are generated. The reports require the flexibility of Excel, the analysis power of JMP® and SAS®, and the reporting convenience of PowerPoint. This can be accomplished by integrating JMP, SAS® ODS,...
متن کامل